create table qrtz_scheduler_state
(
    sched_name        nvarchar(120) not null,
    instance_name     nvarchar(200) not null,
    last_checkin_time bigint        not null,
    checkin_interval  bigint        not null,
    primary key (sched_name, instance_name)
)
go

exec sp_addextendedproperty 'MS_Description', '调度器状态表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_scheduler_state'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_scheduler_state', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', '实例名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_scheduler_state', 'COLUMN',
     'instance_name'
go

exec sp_addextendedproperty 'MS_Description', '上次检查时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_scheduler_state', 'COLUMN',
     'last_checkin_time'
go

exec sp_addextendedproperty 'MS_Description', '检查间隔时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_scheduler_state', 'COLUMN',
     'checkin_interval'
go

INSERT INTO [ry-vue].dbo.qrtz_scheduler_state (sched_name, instance_name, last_checkin_time, checkin_interval) VALUES (N'RuoyiScheduler', N'DELL-20161646031020700', 1646031258676, 15000);